/* instructions to fill-in breeds */
INSERT INTO breeds VALUES(1,'Witch or Wizard');
INSERT INTO breeds VALUES(2,'Centaur');
INSERT INTO breeds VALUES(3,'Muggle');
INSERT INTO breeds VALUES(4,'Goblin');
INSERT INTO breeds VALUES(5,'Troll');
INSERT INTO breeds VALUES(6,'Giant');
INSERT INTO breeds VALUES(7,'Elf');
INSERT INTO breeds VALUES(8,'Spider');
INSERT INTO breeds VALUES(9,'Snake');
INSERT INTO breeds VALUES(10,'Dragon');
INSERT INTO breeds VALUES(11,'Half-giant');
INSERT INTO breeds VALUES(12,'Werewolf');
INSERT INTO breeds VALUES(13,'Dementor');
INSERT INTO breeds VALUES(14,'Gargoyle');
INSERT INTO breeds VALUES(15,'Squib');
INSERT INTO breeds VALUES(16,'Ghost');
INSERT INTO breeds VALUES(17,'Poltergeist');
INSERT INTO breeds VALUES(18,'Ghoul');

/* instructions to fill-in houses */
INSERT INTO houses VALUES(1,'Griffindor');
INSERT INTO houses VALUES(2,'Ravenclaw');
INSERT INTO houses VALUES(3,'Hufflepuff');
INSERT INTO houses VALUES(4,'Slytherin');

/* instructions to fill-in subjects */
INSERT INTO subjects VALUES(1,'Apparition');
INSERT INTO subjects VALUES(2,'Arithmancy');
INSERT INTO subjects VALUES(3,'Astronomy');
INSERT INTO subjects VALUES(4,'Care of Magical Creatures');
INSERT INTO subjects VALUES(5,'Charms');
INSERT INTO subjects VALUES(6,'Defence Against the Dark Arts');
INSERT INTO subjects VALUES(7,'Divination');
INSERT INTO subjects VALUES(8,'Flying');
INSERT INTO subjects VALUES(9,'Ghoul Studies');
INSERT INTO subjects VALUES(10,'Herbology');
INSERT INTO subjects VALUES(11,'History of Magic');
INSERT INTO subjects VALUES(12,'Muggle Music');
INSERT INTO subjects VALUES(13,'Muggle Studies');
INSERT INTO subjects VALUES(14,'Occlumency');
INSERT INTO subjects VALUES(15,'Potions');
INSERT INTO subjects VALUES(16,'Study of Ancient Runes');
INSERT INTO subjects VALUES(17,'Transfiguration');

/* instructions to fill-in characters */
INSERT INTO characters VALUES(1,'Albus','Dumbledore','M',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(2,'Minerva','McGonagall','F',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(3,'Galatea','Merrythought','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(4,'Quirinus','Quirrell','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(5,'Gilderoy','Lockhart','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(6,'Remus','Lupin','M',NULL,NULL,'Moony','12',NULL,'1');
INSERT INTO characters VALUES(7,'Alastor','Moody','M',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(8,'Dolores','Umbridge','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(9,'Severus','Snape','M',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(10,'Amycus','Carrow','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(11,'Horace','Slughorn','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(12,'Silvanus','Kettleburn','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(13,'Rubeus','Hagrid','M',NULL,NULL,NULL,'11',NULL,'1');
INSERT INTO characters VALUES(14,'Wilhelmina','Grubbly-Plank','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(15,'Pomona','Sprout','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(16,'Neville','Longbottom','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(17,'Filius','Flitwick','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(18,'Sybill','Trelawney','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(19,'Firenze',NULL,'M',NULL,NULL,NULL,'2',NULL,NULL);
INSERT INTO characters VALUES(20,'Herbert','Beery','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(21,'Aurora','Sinistra','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(22,'Rolanda','Hooch','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(23,'Bathsheda','Babbling','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(24,'Cuthbert','Binns','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(25,'Septima','Vector','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(26,'Charity','Burbage','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(27,'Alecto','Carrow','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(28,'Godric','Gryffindor','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(29,'Helga','Hufflepuff','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(30,'Rowena','Ravenclaw','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(31,'Salazar','Slytherin','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(32,NULL,'Everard','M','Professor',NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(33,'Dilys','Derwent','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(34,'Phineas','Nigellus Black','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(35,'Dexter','Fortescue','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(36,'Newt','Scamander','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(37,'Armando','Dippet','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(38,'Harry','Potter','M',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(39,'Ron','Weasley','M',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(40,'Hermione','Granger','F',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(43,'James','Potter','M',NULL,NULL,'Prongs','1',NULL,NULL);
INSERT INTO characters VALUES(44,'Lily','Evans','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(45,'Sirius','Black','M',NULL,NULL,'Padfoot','1',NULL,'1');
INSERT INTO characters VALUES(47,'Ginny','Weasley','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(49,'Nymphadora','Tonks','F',NULL,NULL,NULL,'1',NULL,'1');
INSERT INTO characters VALUES(51,'Cedric','Diggory','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(52,'Hannah','Abbott','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(53,'Ernie','Macmillan','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(54,'Luna','Lovegood','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(55,'Cho','Chang','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(56,'Roger','Davies','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(57,'Michael','Corner','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(59,'Tom','Riddle','M',NULL,NULL,'The Dark Lord','1','1',NULL);
INSERT INTO characters VALUES(60,'Draco','Malfoy','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(61,'Lucius','Malfoy','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(62,'Bellatrix','Lestrange','F',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(63,'Narcissa','Malfoy','F',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(64,'Regulus','Black','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(65,'Horace','Slughorn','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(67,'Vincent','Crabbe','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(68,'Gregory','Goyle','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(70,'Nicholas','de Mimsy-Porpington','M','Sir',NULL,'Nearly Headless Nick','16',NULL,NULL);
INSERT INTO characters VALUES(71,'Fat','Friar','M',NULL,NULL,'The Fat Friar','16',NULL,NULL);
INSERT INTO characters VALUES(72,'Helena','Ravenclaw','F',NULL,NULL,'The Grey Lady','16',NULL,NULL);
INSERT INTO characters VALUES(73,'Bloody','Baron','M',NULL,NULL,'The Bloody Baron','16',NULL,NULL);
INSERT INTO characters VALUES(74,'Griphook',NULL,'M',NULL,NULL,NULL,'4',NULL,NULL);
INSERT INTO characters VALUES(75,'Ragnuk',NULL,'M',NULL,NULL,NULL,'4',NULL,NULL);
INSERT INTO characters VALUES(76,'Nagnok',NULL,'M',NULL,NULL,NULL,'4',NULL,NULL);
INSERT INTO characters VALUES(77,'Hodrod',NULL,'M',NULL,NULL,NULL,'4',NULL,NULL);
INSERT INTO characters VALUES(78,'Gringott',NULL,'M',NULL,NULL,NULL,'4',NULL,NULL);
INSERT INTO characters VALUES(79,'Bogrod',NULL,'M',NULL,NULL,NULL,'4',NULL,NULL);
INSERT INTO characters VALUES(80,'Barty','Crouch','M',NULL,'Jr',NULL,'1','1',NULL);
INSERT INTO characters VALUES(82,'Rodolphus','Lestrange','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(83,'Rabastan','Lestrange','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(84,'Evan','Rosier','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(85,'Igor','Karkaroff','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(86,NULL,'Nott','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(87,'Walden','Macnair','M',NULL,NULL,NULL,'1','1',NULL);
INSERT INTO characters VALUES(88,NULL,'Goyle','M',NULL,'Sr',NULL,'1','1',NULL);
INSERT INTO characters VALUES(89,NULL,'Crabbe','M',NULL,'Sr',NULL,'1','1',NULL);
INSERT INTO characters VALUES(90,'Peter','Pettigrew',NULL,NULL,NULL,'Wormtail','1','1',NULL);
INSERT INTO characters VALUES(95,'Cornelius','Fudge','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(96,'Bartemius','Crouch','M',NULL,'Sr',NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(97,'Rufus','Scrimgeour','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(100,'Kingsley','Shacklebolt','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(101,'Alice','Longbottom','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(102,'Frank','Longbottom','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(104,'Nymphadora','Tonks','F',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(105,'Mundungus','Fletcher','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(110,'Peeves',NULL,'M',NULL,NULL,NULL,'17',NULL,NULL);
INSERT INTO characters VALUES(120,'Dobby',NULL,'M',NULL,NULL,NULL,'7',NULL,NULL);
INSERT INTO characters VALUES(121,'Kreacher',NULL,'M',NULL,NULL,NULL,'7',NULL,NULL);
INSERT INTO characters VALUES(122,'Hokey',NULL,'M',NULL,NULL,NULL,'7',NULL,NULL);
INSERT INTO characters VALUES(123,'Winky',NULL,'F',NULL,NULL,NULL,'7',NULL,NULL);
INSERT INTO characters VALUES(130,'Ted','Tonks','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(131,NULL,'Ollivander','M','Mr',NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(132,'Aberforth','Dumbledore','M',NULL,NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(133,NULL,'Puddifoot','F','Madam',NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(134,NULL,'Rosmerta','F','Madam',NULL,NULL,'1',NULL,NULL);
INSERT INTO characters VALUES(140,'Aragog',NULL,'M',NULL,NULL,NULL,'8',NULL,NULL);
INSERT INTO characters VALUES(150,'Petunia','Evans','F',NULL,NULL,NULL,'3',NULL,NULL);
INSERT INTO characters VALUES(151,'Vernon','Dursley','M',NULL,NULL,NULL,'3',NULL,NULL);
INSERT INTO characters VALUES(152,'Dudley','Dursley','M',NULL,NULL,NULL,'3',NULL,NULL);
INSERT INTO characters VALUES(160,'Grawp',NULL,'M',NULL,NULL,NULL,'6',NULL,NULL);
INSERT INTO characters VALUES(161,'Golgomath',NULL,'M',NULL,NULL,NULL,'6',NULL,NULL);
INSERT INTO characters VALUES(162,'Morholt',NULL,'M',NULL,NULL,NULL,'6',NULL,NULL);
INSERT INTO characters VALUES(163,'Olympe','Maxime','F','Madame',NULL,NULL,'11',NULL,NULL);

/* instructions to fill-in teachers */
INSERT INTO teaches VALUES(1,17,NULL,NULL);
INSERT INTO teaches VALUES(2,17,NULL,NULL);
INSERT INTO teaches VALUES(3,6,NULL,NULL);
INSERT INTO teaches VALUES(4,13,NULL,NULL);
INSERT INTO teaches VALUES(4,6,NULL,NULL);
INSERT INTO teaches VALUES(5,6,NULL,NULL);
INSERT INTO teaches VALUES(6,6,NULL,NULL);
INSERT INTO teaches VALUES(7,6,NULL,NULL);
INSERT INTO teaches VALUES(8,6,NULL,NULL);
INSERT INTO teaches VALUES(9,15,NULL,NULL);
INSERT INTO teaches VALUES(9,6,NULL,NULL);
INSERT INTO teaches VALUES(10,6,NULL,NULL);
INSERT INTO teaches VALUES(11,15,NULL,NULL);
INSERT INTO teaches VALUES(12,4,NULL,NULL);
INSERT INTO teaches VALUES(13,4,NULL,NULL);
INSERT INTO teaches VALUES(14,4,NULL,NULL);
INSERT INTO teaches VALUES(15,10,NULL,NULL);
INSERT INTO teaches VALUES(16,10,NULL,NULL);
INSERT INTO teaches VALUES(17,5,NULL,NULL);
INSERT INTO teaches VALUES(18,7,NULL,NULL);
INSERT INTO teaches VALUES(19,7,NULL,NULL);
INSERT INTO teaches VALUES(20,10,NULL,NULL);
INSERT INTO teaches VALUES(21,3,NULL,NULL);
INSERT INTO teaches VALUES(22,8,NULL,NULL);
INSERT INTO teaches VALUES(23,16,NULL,NULL);
INSERT INTO teaches VALUES(24,11,NULL,NULL);
INSERT INTO teaches VALUES(25,2,NULL,NULL);
INSERT INTO teaches VALUES(26,13,NULL,NULL);
INSERT INTO teaches VALUES(27,13,NULL,NULL);

/* instructions to fill-in students */
INSERT INTO studies VALUES(38,NULL,NULL,'1');
INSERT INTO studies VALUES(39,NULL,NULL,'1');
INSERT INTO studies VALUES(40,NULL,NULL,'1');
INSERT INTO studies VALUES(43,NULL,NULL,'1');
INSERT INTO studies VALUES(44,NULL,NULL,'1');
INSERT INTO studies VALUES(45,NULL,NULL,'1');
INSERT INTO studies VALUES(47,NULL,NULL,'1');
INSERT INTO studies VALUES(49,NULL,NULL,'2');
INSERT INTO studies VALUES(51,NULL,NULL,'2');
INSERT INTO studies VALUES(52,NULL,NULL,'2');
INSERT INTO studies VALUES(53,NULL,NULL,'2');
INSERT INTO studies VALUES(54,NULL,NULL,'3');
INSERT INTO studies VALUES(55,NULL,NULL,'3');
INSERT INTO studies VALUES(56,NULL,NULL,'3');
INSERT INTO studies VALUES(57,NULL,NULL,'3');
INSERT INTO studies VALUES(59,NULL,NULL,'4');
INSERT INTO studies VALUES(60,NULL,NULL,'4');
INSERT INTO studies VALUES(61,NULL,NULL,'4');
INSERT INTO studies VALUES(62,NULL,NULL,'4');
INSERT INTO studies VALUES(63,NULL,NULL,'4');
INSERT INTO studies VALUES(64,NULL,NULL,'4');
INSERT INTO studies VALUES(65,NULL,NULL,'4');
INSERT INTO studies VALUES(67,NULL,NULL,'4');
INSERT INTO studies VALUES(68,NULL,NULL,'4');

/* instructions to fill-in headmasters */
INSERT INTO is_headmaster VALUES(1,NULL,NULL);
INSERT INTO is_headmaster VALUES(2,NULL,NULL);
INSERT INTO is_headmaster VALUES(8,NULL,NULL);
INSERT INTO is_headmaster VALUES(28,NULL,NULL);
INSERT INTO is_headmaster VALUES(29,NULL,NULL);
INSERT INTO is_headmaster VALUES(30,NULL,NULL);
INSERT INTO is_headmaster VALUES(31,NULL,NULL);
INSERT INTO is_headmaster VALUES(32,NULL,NULL);
INSERT INTO is_headmaster VALUES(33,NULL,NULL);
INSERT INTO is_headmaster VALUES(34,NULL,NULL);
INSERT INTO is_headmaster VALUES(35,NULL,NULL);
INSERT INTO is_headmaster VALUES(36,NULL,NULL);
INSERT INTO is_headmaster VALUES(37,NULL,NULL);

/* instructions to fill-in heads_of_houses */
INSERT INTO is_head_of_house VALUES(1,1,NULL,NULL);
INSERT INTO is_head_of_house VALUES(2,1,NULL,NULL);
INSERT INTO is_head_of_house VALUES(9,1,NULL,NULL);
INSERT INTO is_head_of_house VALUES(11,4,NULL,NULL);
INSERT INTO is_head_of_house VALUES(15,3,NULL,NULL);
INSERT INTO is_head_of_house VALUES(17,2,NULL,NULL);